Materialized views and data warehouses
نویسندگان
چکیده
منابع مشابه
Materialized Data Mining Views
Data mining is a useful decision support technique, which can be used to find trends and regularities in warehouses of corporate data. A serious problem of its practical applications is long processing time required by data mining algorithms. Current systems consume minutes or hours to answer simple queries. In this paper we present the concept of materialized data mining views. Materialized da...
متن کاملThe Opsis Project: Materialized Views for Data Warehouses and the Web
The real world we live in is mostly perceived through an incredibly large collection of views generated by humans, machines, and other systems. This is the view reality. The Opsis project concentrates its efforts in dealing with the multifaceted form and complexity of data views including data projection views, aggregateviews, summary views (synopses), point of view views, and finally web views...
متن کاملRewriting OLAP Queries Using Materialized Views and Dimension Hierarchies in Data Warehouses
OLAP queries involve a lot of aggregations on a large amount of data in data warehouses. To process expensive OLAP queries efficiently, we propose a new method for rewriting a given OLAP query using various kinds of materialized aggregate views which already exist in data warehouses. We first define the normal forms of OLAP queries and materialized views based on the lattice of dimension hierar...
متن کاملMaterialized Views in Data Mining
Relational views are used both as a specification technique and as an execution plan for the derivation of the warehouse data. Currently available mining algorithms suffer from long processing times depending mainly on the size of the dataset. One observation is that the results of consecutive data mining queries are usually very similar. This observation leads to the idea of reusing materializ...
متن کاملBringing Together Partitioning, Materialized Views and Indexes to Optimize Performance of Relational Data Warehouses
There has been a lot of work to optimize the performance of relational data warehouses. Three major techniques can be used for this objective : enhanced index schemes (join indexes, bitmap indexes), materialized views, and data partitioning. The existing research prototypes or products use materialized views alone or indexes alone or combination of them, but none of the prototypes use all three...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: ACM SIGMOD Record
سال: 1998
ISSN: 0163-5808
DOI: 10.1145/273244.273253